﻿CREATE TABLE [acms].[Site]
(
	Id int NOT NULL identity (1,1), 
	Name varchar(20) NOT NULL,
	RootUrl varchar(255) NOT NULL,
	CreatedDateTime datetime NOT NULL default(GetDate()), 
	CID int NOT NULL default 0,
	Deleted bit NOT NULL default((0))
);
